package com.shujia.wyh.utils;

import java.sql.PreparedStatement;
import java.sql.SQLException;

public class ExtendsData {
    public static void main(String[] args) throws SQLException {
        PreparedStatement prep = MySqlTool.getConnection("insert into emp (empno,ename,job,mgr,hiredate,sal,comm,deptno) values (?,?,?,?,?,?,?,?)");

        long start = System.currentTimeMillis();
        for(Integer empno = 9000;empno<=59000;empno++){
            prep.setString(1,empno.toString());
            prep.setString(2,"xiaohu"+empno);
            prep.setString(3,"bigdata"+empno);
            prep.setString(4,"xiaoge"+empno);
            prep.setString(5,"2022-08-18");
            prep.setString(6,"10000");
            prep.setString(7,"20000");
            prep.setString(8,"20");
            prep.executeUpdate();
        }
        long end = System.currentTimeMillis();
        System.out.println((end-start)/1000+"秒");
        System.out.println("数据扩大完毕");

    }
}
